﻿using Wicresoft.SMS.Data;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using System;
using System.Collections.Generic;

namespace SMS.Gateway.Host.Test
{
    
    
    /// <summary>
    ///This is a test class for sqlReportWebDataAccessTest and is intended
    ///to contain all sqlReportWebDataAccessTest Unit Tests
    ///</summary>
    [TestClass()]
    public class sqlReportWebDataAccessTest
    {


        private TestContext testContextInstance;

        /// <summary>
        ///Gets or sets the test context which provides
        ///information about and functionality for the current test run.
        ///</summary>
        public TestContext TestContext
        {
            get
            {
                return testContextInstance;
            }
            set
            {
                testContextInstance = value;
            }
        }

        #region Additional test attributes
        // 
        //You can use the following additional attributes as you write your tests:
        //
        //Use ClassInitialize to run code before running the first test in the class
        //[ClassInitialize()]
        //public static void MyClassInitialize(TestContext testContext)
        //{
        //}
        //
        //Use ClassCleanup to run code after all tests in a class have run
        //[ClassCleanup()]
        //public static void MyClassCleanup()
        //{
        //}
        //
        //Use TestInitialize to run code before running each test
        //[TestInitialize()]
        //public void MyTestInitialize()
        //{
        //}
        //
        //Use TestCleanup to run code after each test has run
        //[TestCleanup()]
        //public void MyTestCleanup()
        //{
        //}
        //
        #endregion


        /// <summary>
        ///A test for sqlReportWebDataAccess Constructor
        ///</summary>
        [TestMethod()]
        public void sqlReportWebDataAccessConstructorTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString);
            Assert.Inconclusive("TODO: Implement code to verify target");
        }

        /// <summary>
        ///A test for DeleteMessageById
        ///</summary>
        [TestMethod()]
        public void DeleteMessageByIdTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            int Id = 0; // TODO: Initialize to an appropriate value
            bool expected = false; // TODO: Initialize to an appropriate value
            bool actual;
            actual = target.DeleteMessageById(Id);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetDepartnameById
        ///</summary>
        [TestMethod()]
        public void GetDepartnameByIdTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            int DepartmentId = 0; // TODO: Initialize to an appropriate value
            string expected = string.Empty; // TODO: Initialize to an appropriate value
            string actual;
            actual = target.GetDepartnameById(DepartmentId);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetGroupIdByUserId
        ///</summary>
        [TestMethod()]
        [DeploymentItem("SMS.Data.dll")]
        public void GetGroupIdByUserIdTest()
        {
            PrivateObject param0 = null; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess_Accessor target = new sqlReportWebDataAccess_Accessor(param0); // TODO: Initialize to an appropriate value
            int UserId = 0; // TODO: Initialize to an appropriate value
            int expected = 0; // TODO: Initialize to an appropriate value
            int actual;
            actual = target.GetGroupIdByUserId(UserId);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetHistoryByAll
        ///</summary>
        [TestMethod()]
        public void GetHistoryByAllTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            int PageIndex = 0; // TODO: Initialize to an appropriate value
            int MaxShow = 0; // TODO: Initialize to an appropriate value
            ViewHistoryType Type = new ViewHistoryType(); // TODO: Initialize to an appropriate value
            string Search = string.Empty; // TODO: Initialize to an appropriate value
            int BatchId = 0; // TODO: Initialize to an appropriate value
            List<HistoryInfoModel> expected = null; // TODO: Initialize to an appropriate value
            List<HistoryInfoModel> actual;
            actual = target.GetHistoryByAll(PageIndex, MaxShow, Type, Search, BatchId);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetHistoryByDay
        ///</summary>
        [TestMethod()]
        [DeploymentItem("SMS.Data.dll")]
        public void GetHistoryByDayTest()
        {
            PrivateObject param0 = null; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess_Accessor target = new sqlReportWebDataAccess_Accessor(param0); // TODO: Initialize to an appropriate value
            DateTime StartTime = new DateTime(); // TODO: Initialize to an appropriate value
            DateTime EndTime = new DateTime(); // TODO: Initialize to an appropriate value
            List<HistoryReport> expected = null; // TODO: Initialize to an appropriate value
            List<HistoryReport> actual;
            actual = target.GetHistoryByDay(StartTime, EndTime);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetHistoryByGroup
        ///</summary>
        [TestMethod()]
        public void GetHistoryByGroupTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            int PageIndex = 0; // TODO: Initialize to an appropriate value
            int MaxShow = 0; // TODO: Initialize to an appropriate value
            int GroupId = 0; // TODO: Initialize to an appropriate value
            ViewHistoryType Type = new ViewHistoryType(); // TODO: Initialize to an appropriate value
            string Search = string.Empty; // TODO: Initialize to an appropriate value
            List<HistoryInfoModel> expected = null; // TODO: Initialize to an appropriate value
            List<HistoryInfoModel> actual;
            actual = target.GetHistoryByGroup(PageIndex, MaxShow, GroupId, Type, Search);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetHistoryByMouth
        ///</summary>
        [TestMethod()]
        [DeploymentItem("SMS.Data.dll")]
        public void GetHistoryByMouthTest()
        {
            PrivateObject param0 = null; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess_Accessor target = new sqlReportWebDataAccess_Accessor(param0); // TODO: Initialize to an appropriate value
            DateTime StartTime = new DateTime(); // TODO: Initialize to an appropriate value
            DateTime EndTime = new DateTime(); // TODO: Initialize to an appropriate value
            List<HistoryReport> expected = null; // TODO: Initialize to an appropriate value
            List<HistoryReport> actual;
            actual = target.GetHistoryByMouth(StartTime, EndTime);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetHistoryByUser
        ///</summary>
        [TestMethod()]
        public void GetHistoryByUserTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            int PageIndex = 0; // TODO: Initialize to an appropriate value
            int MaxShow = 0; // TODO: Initialize to an appropriate value
            int UserId = 0; // TODO: Initialize to an appropriate value
            ViewHistoryType Type = new ViewHistoryType(); // TODO: Initialize to an appropriate value
            string Search = string.Empty; // TODO: Initialize to an appropriate value
            List<HistoryInfoModel> expected = null; // TODO: Initialize to an appropriate value
            List<HistoryInfoModel> actual;
            actual = target.GetHistoryByUser(PageIndex, MaxShow, UserId, Type, Search);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetHistoryByWeek
        ///</summary>
        [TestMethod()]
        [DeploymentItem("SMS.Data.dll")]
        public void GetHistoryByWeekTest()
        {
            PrivateObject param0 = null; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess_Accessor target = new sqlReportWebDataAccess_Accessor(param0); // TODO: Initialize to an appropriate value
            DateTime StartTime = new DateTime(); // TODO: Initialize to an appropriate value
            DateTime EndTime = new DateTime(); // TODO: Initialize to an appropriate value
            List<HistoryReport> expected = null; // TODO: Initialize to an appropriate value
            List<HistoryReport> actual;
            actual = target.GetHistoryByWeek(StartTime, EndTime);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetHistoryByYear
        ///</summary>
        [TestMethod()]
        [DeploymentItem("SMS.Data.dll")]
        public void GetHistoryByYearTest()
        {
            PrivateObject param0 = null; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess_Accessor target = new sqlReportWebDataAccess_Accessor(param0); // TODO: Initialize to an appropriate value
            DateTime StartTime = new DateTime(); // TODO: Initialize to an appropriate value
            DateTime EndTime = new DateTime(); // TODO: Initialize to an appropriate value
            List<HistoryReport> expected = null; // TODO: Initialize to an appropriate value
            List<HistoryReport> actual;
            actual = target.GetHistoryByYear(StartTime, EndTime);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetPageCount
        ///</summary>
        [TestMethod()]
        public void GetPageCountTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            ViewHistoryType Type = new ViewHistoryType(); // TODO: Initialize to an appropriate value
            ViewHistoryRole Role = new ViewHistoryRole(); // TODO: Initialize to an appropriate value
            int Id = 0; // TODO: Initialize to an appropriate value
            int MaxShow = 0; // TODO: Initialize to an appropriate value
            string Search = string.Empty; // TODO: Initialize to an appropriate value
            int BatchId = 0; // TODO: Initialize to an appropriate value
            int expected = 0; // TODO: Initialize to an appropriate value
            int actual;
            actual = target.GetPageCount(Type, Role, Id, MaxShow, Search, BatchId);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetTotalMessage
        ///</summary>
        [TestMethod()]
        public void GetTotalMessageTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            DateTime StartTime = new DateTime(); // TODO: Initialize to an appropriate value
            int expected = 0; // TODO: Initialize to an appropriate value
            int actual;
            actual = target.GetTotalMessage(StartTime);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for GetUserNameById
        ///</summary>
        [TestMethod()]
        [DeploymentItem("SMS.Data.dll")]
        public void GetUserNameByIdTest()
        {
            PrivateObject param0 = null; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess_Accessor target = new sqlReportWebDataAccess_Accessor(param0); // TODO: Initialize to an appropriate value
            int UserId = 0; // TODO: Initialize to an appropriate value
            string expected = string.Empty; // TODO: Initialize to an appropriate value
            string actual;
            actual = target.GetUserNameById(UserId);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for QueryGroupReport
        ///</summary>
        [TestMethod()]
        public void QueryGroupReportTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            DateTime StartTime = new DateTime(); // TODO: Initialize to an appropriate value
            DateTime EndTime = new DateTime(); // TODO: Initialize to an appropriate value
            int MaxShow = 0; // TODO: Initialize to an appropriate value
            List<GroupReport> expected = null; // TODO: Initialize to an appropriate value
            List<GroupReport> actual;
            actual = target.QueryGroupReport(StartTime, EndTime, MaxShow);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for QueryHistoryReport
        ///</summary>
        [TestMethod()]
        public void QueryHistoryReportTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            DateTime StartTime = new DateTime(); // TODO: Initialize to an appropriate value
            DateTime EndTime = new DateTime(); // TODO: Initialize to an appropriate value
            queryFrequence Frequence = new queryFrequence(); // TODO: Initialize to an appropriate value
            List<HistoryReport> expected = null; // TODO: Initialize to an appropriate value
            List<HistoryReport> actual;
            actual = target.QueryHistoryReport(StartTime, EndTime, Frequence);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for QueryIndividualReprot
        ///</summary>
        [TestMethod()]
        public void QueryIndividualReprotTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            int GroupId = 0; // TODO: Initialize to an appropriate value
            DateTime StartTime = new DateTime(); // TODO: Initialize to an appropriate value
            DateTime EndTime = new DateTime(); // TODO: Initialize to an appropriate value
            int MaxShow = 0; // TODO: Initialize to an appropriate value
            List<IndividualReprot> expected = null; // TODO: Initialize to an appropriate value
            List<IndividualReprot> actual;
            actual = target.QueryIndividualReprot(GroupId, StartTime, EndTime, MaxShow);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for ResentMessage
        ///</summary>
        [TestMethod()]
        public void ResentMessageTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            int BatchId = 0; // TODO: Initialize to an appropriate value
            bool expected = false; // TODO: Initialize to an appropriate value
            bool actual;
            actual = target.ResentMessage(BatchId);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }

        /// <summary>
        ///A test for ResentMessageById
        ///</summary>
        [TestMethod()]
        public void ResentMessageByIdTest()
        {
            string ConnectionString = string.Empty; // TODO: Initialize to an appropriate value
            sqlReportWebDataAccess target = new sqlReportWebDataAccess(ConnectionString); // TODO: Initialize to an appropriate value
            int Id = 0; // TODO: Initialize to an appropriate value
            bool expected = false; // TODO: Initialize to an appropriate value
            bool actual;
            actual = target.ResentMessageById(Id);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }
    }
}
